Release 10.1A: OpenEdge Data Management:
SQL Reference

FLOOR

Returns the largest integer less than or equal to expression.

Syntax

FLOOR ( expression )

Example

This example illustrates the FLOOR function:

SELECT FLOOR (32.5) 'Floor' from sysprogress.syscalctable ;

Note

expression must evaluate to a numeric data type.

Compatibility

ODBC compatible